How to export Database Structure

Open Microsoft SQL Enterprise Manager from:

[Start] -> Programs -> Microsoft SQL Server -> Enterprise Manager

Expand tree and Select your database:

Choose from Menu

Tools -> Generate SQL Script...

Then new window will open, press [Show All] button and select all checkboxes as shown below:

Please do not check [ ] Include Descriptive headers in the script files as it makes MD5 comparison of diferrent backups imposible:

Please select (o) Create one file per object if  you need to prepare just for partial revert:

If you are planing to send backup by email then you can unselect these options:
   [ ] Script database users and database roles
   [ ] Script SQL Server logins (Windows and SQL Server logins)

Click [OK] button. Browse/Save Dialog will open.:

Save Dialog for one file per object (Select Folder name and hit [OK] button):

Save Dialog for one file (Enter file name and hit [Save] button):